Numeric Expressions

A numeric expression is a combination of numeric elements (such as numbers, variables, and functions) and operators that evaluates to a numeric value.

An expression can contain any of the following in any combination:

Arrays

Mathematical operators

Attributes

Name-Index numbers

Boolean operators

Numbers

Distributions

Subroutines

Macros

System functions

Math function table functions

Variables

The following mathematical operators are available:

Operator

Meaning

Example

+

Addition

A=B+C

-

Subtraction

A=B-C

*

Multiplication

A=B*C

/

Division

A=B/C

Mod or @

Modulus

A=B Mod C (assigns the remainder of B divided by C to A)

**

Exponentiation

A=B**C (assigns the value of B raised to the C power)

You can perform additional mathematical operations using math functions. For more information on operator precedence rules and expression nesting, see Operator Precedence.

Please note

In each of the examples above, if A is an integer number and B and C are both real numbers, the result will be truncated unless ROUND() is used (e.g., A = ROUND(B+C)).